TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `insert_THANHTIENNHAP` BEFORE INSERT ON `chitietphieunhap`\nFOR EACH ROW SET NEW.THANHTIENNHAP = NEW.SOLUONGNHAP * NEW.DONGIANHAP' 'CREATE DEFINER=`root`@`localhost` TRIGGER `insert_SOLUONGNHAP` AFTER INSERT ON `chitietphieunhap`\nFOR EACH ROW if new.SOLUONGNHAP <= 0  then\nsignal sqlstate \'10501\' set message_text =\'SO LUONG NHAP PHAI LỚN HƠN KHÔNG\';\nend if' 'CREATE DEFINER=`root`@`localhost` TRIGGER `Update_THANHTIENNHAP` BEFORE UPDATE ON `chitietphieunhap`\nFOR EACH ROW SET NEW.THANHTIENNHAP = NEW.SOLUONGNHAP * NEW.DONGIANHAP'
sql_modes=0 0 0
definers='root@localhost' 'root@localhost' 'root@localhost'
client_cs_names='utf8' 'utf8' 'utf8'
connection_cl_names='utf8_general_ci' 'utf8_general_ci' 'utf8_general_ci'
db_cl_names='utf8_general_ci' 'utf8_general_ci' 'utf8_general_ci'
